What Your Carrier Reads in Your Claims Workflow Reports and Why It Decides Your MGA's Future

Your carrier partner does not sit in your claims department. The bordereaux you submit each month, the loss ratio summaries you file quarterly, and the reserve development reports you deliver on schedule are the lens through which they judge your entire operation. A single inaccurate report or missed deadline signals operational weakness that no amount of strong claims processing can overcome.

Most new pet insurance MGAs underestimate this reality, treating claims workflow reporting as an administrative afterthought while focusing on adjudication speed and customer satisfaction. That priorities gap is exactly what leads to the reporting quality problems that a 2025 NAPHIA survey found responsible for 68 percent of carrier-MGA relationship issues. Your reporting infrastructure must be designed alongside your claims processing system, not bolted on after launch.

According to NAPHIA's 2025 program management survey, 68 percent of carrier-MGA relationship issues originate from reporting quality problems rather than underwriting or claims handling disputes. A 2025 Conning analysis of MGA program terminations found that reporting failures contributed to 40 percent of involuntary program wind-downs in personal lines.

What Monthly Claims Reports Do Carriers Require From Pet Insurance MGAs?

Carriers require pet insurance MGAs to submit monthly claims bordereaux, paid and incurred loss summaries, open claims inventories, large loss notifications, prompt payment compliance reports, and claims staffing updates. These reports give the carrier a granular, near-real-time view of the MGA's claims operation and financial position.

1. Monthly Claims Bordereaux

The claims bordereaux is the cornerstone of carrier reporting. It is a line-by-line listing of every claim that was opened, updated, or closed during the reporting month. Each row represents a single claim and must include standardized fields that the carrier uses for financial accounting, reserve validation, reinsurance reporting, and regulatory compliance.

Bordereaux Field	Description	Format Requirement
Claim Number	Unique identifier for each claim	MGA system-generated, sequential
Policy Number	Associated policy identifier	Must match policy bordereaux
Date of Loss	When the pet illness/injury occurred	YYYY-MM-DD format
Date Reported	When the MGA received the claim	YYYY-MM-DD format
Diagnosis	Primary veterinary diagnosis	Standardized diagnosis code or description
Amount Paid	Total paid on the claim to date	Currency, two decimal places
Amount Reserved	Outstanding reserve for the claim	Currency, two decimal places
Incurred Amount	Paid plus reserved	Auto-calculated
Claim Status	Open, closed, reopened, or denied	Carrier-defined status codes
Denial Reason	If denied, the specific reason code	Carrier-defined denial codes

2. Paid and Incurred Loss Summary

Beyond the detailed bordereaux, carriers require a summary-level report aggregating total paid losses, total incurred losses (paid plus outstanding reserves), the number of claims by status, and the earned premium for the reporting period. This summary serves as the basis for loss ratio calculations and premium adequacy monitoring.

3. Open Claims Inventory Report

The open claims inventory provides a snapshot of all claims that remain unresolved at month end. For each open claim, the report should include the aging (days since filing), current reserve amount, last action taken, and next expected action. Carriers use this report to identify stale claims, assess reserve adequacy on individual files, and evaluate the MGA's claims pipeline management.

4. Large Loss Notifications

Most carrier agreements define a large loss threshold, typically claims exceeding $3,000 to $5,000 for pet insurance. Any claim that reaches or is expected to reach this threshold requires immediate notification to the carrier, often within 24 to 48 hours, followed by detailed reporting in the monthly package. Large loss notifications include the veterinary diagnosis, treatment plan, projected total cost, and any complicating factors.

MGAs that have established strong claims handling infrastructure from the outset will find that monthly reporting is a natural output of well-designed systems rather than a scramble to assemble data.

Automate your monthly carrier reporting and never miss a deadline.

Talk to Our Specialists

Visit Insurnest to learn how we help MGAs launch and scale pet insurance programs.

What Quarterly Claims Reports Do Carriers Require From Pet Insurance MGAs?

Quarterly reporting builds on monthly data by adding aggregate trend analysis, reserve development summaries, fraud detection reports, quality audit results, and compliance exception documentation. These reports give the carrier a strategic view of program trajectory beyond the operational detail of monthly submissions.

The quarterly loss ratio report presents earned premium, incurred losses, and the resulting loss ratio for the quarter and year-to-date, segmented by product type, coverage tier, geographic region, and pet species where applicable. Carriers expect trend charts showing month-over-month loss ratio movement and commentary explaining any significant deviations from the expected range.

Loss Ratio Metric	Reporting Format	Carrier Use
Gross Loss Ratio	Incurred / earned premium by quarter	Primary profitability indicator
Net Loss Ratio	After reinsurance recoveries	Carrier's retained risk view
Loss Ratio by Product	Accident-only vs. accident-illness	Product mix profitability
Loss Ratio by State	Geographic profitability analysis	Underwriting appetite adjustment
Loss Ratio Trend	12-month rolling chart	Program trajectory assessment

2. Claims Reserve Development Summary

Reserve development reports compare the reserves held at the end of prior periods against the ultimate outcomes of those claims. Positive development (reserves exceeded ultimate payments) indicates conservative reserving. Negative development (actual payments exceeded reserves) signals potential reserve inadequacy. For new MGAs, carriers scrutinize reserve development closely because the MGA lacks historical data to benchmark against.

Understanding the principles of claims reserve estimation without historical data is directly relevant to producing accurate reserve development reports that satisfy carrier expectations.

3. Fraud Detection Activity Report

Quarterly fraud reporting documents the number of claims flagged for potential fraud, the number investigated, investigation outcomes, recoveries achieved, and referrals to external authorities. Carriers want evidence that the MGA's fraud detection framework is active and producing results, even if the number of confirmed fraud cases is low in the early stages of the program.

4. Claims Quality Audit Results

Carriers expect the MGA to conduct regular quality audits of its own claims handling. Quarterly reports should include audit sample size, audit criteria, pass/fail rates, common deficiency categories, and corrective actions taken. A robust quality audit program demonstrates that the MGA self-polices its operations rather than relying solely on carrier oversight.

5. Compliance Exception Documentation

Any deviations from standard claims protocols, prompt payment deadline breaches, or regulatory inquiries related to claims must be documented and reported quarterly. Transparency about compliance exceptions, combined with evidence of corrective action, builds carrier confidence. Attempting to hide exceptions creates far greater risk if they surface during carrier audits.

How Should New Pet Insurance MGAs Structure Their Reporting Calendar?

New pet insurance MGAs should establish a structured reporting calendar that accounts for data gathering, validation, review, and submission deadlines for both monthly and quarterly reports. Building this calendar before writing the first policy ensures that reporting workflows are operational from day one.

1. Monthly Reporting Timeline

Reporting Step	Timeline	Owner
Month-end data cutoff	Last calendar day	Claims operations
Data extraction and validation	Business days 1-3	Data/reporting team
Bordereaux assembly and reconciliation	Business days 3-5	Data/reporting team
Management review and sign-off	Business days 5-7	Claims director
Carrier submission	By business day 10	Reporting team
Carrier acknowledgment and queries	Business days 10-15	Reporting team
Total Cycle	15 business days	N/A

2. Quarterly Reporting Additions

Quarterly reports typically follow the same monthly timeline plus an additional 5 to 10 business days for trend analysis, reserve development calculations, and narrative commentary. Carriers often allow quarterly reports to be submitted 20 to 25 business days after quarter end.

3. Annual Reporting and Actuarial Opinions

Most carrier agreements require an annual actuarial opinion on reserve adequacy. This requires the MGA to engage an independent actuary 60 to 90 days before the annual reporting deadline, provide complete claims data, and incorporate the actuary's findings into the annual carrier report. New MGAs should budget for this engagement and schedule it during pre-launch planning.

What Data Quality Standards Must MGA Claims Reports Meet?

Carrier claims reports must meet strict data quality standards including completeness (no missing fields), accuracy (amounts reconcile with financial records), consistency (status codes and dates follow logical sequences), and timeliness (submitted by the contractual deadline). Data quality failures erode carrier confidence faster than any other reporting issue.

1. Completeness Requirements

Every field in the bordereaux template must be populated for every claim. Missing data creates gaps in the carrier's ability to aggregate, analyze, and audit MGA claims activity. The claims management system should enforce mandatory field completion at data entry, preventing incomplete claims from progressing through the workflow.

Data Quality Dimension	Standard	Validation Method
Completeness	100% of required fields populated	System-enforced mandatory fields
Accuracy	Amounts match financial ledger	Automated reconciliation
Consistency	Dates and statuses follow logical sequence	Rule-based validation checks
Timeliness	Submitted by contractual deadline	Calendar-driven automated alerts
Formatting	Matches carrier template exactly	Template-locked export functions

2. Reconciliation Between Reports

The total paid and reserved amounts in the bordereaux must reconcile with the paid and incurred loss summary, which must reconcile with the MGA's general ledger, which must reconcile with the trust account transactions. Any discrepancy between these sources creates immediate carrier concern and can trigger ad hoc audits.

3. Automated Validation Before Submission

Before submitting any report, the MGA should run automated validation checks that flag missing data, out-of-range values, status inconsistencies, date sequence errors, and reconciliation mismatches. Fixing these issues before submission prevents the far more damaging scenario of the carrier discovering errors during their own review.

MGAs building their carrier data exchange and reporting technology should prioritize automated validation and reconciliation capabilities in their platform selection.

Ensure every carrier report passes validation before it leaves your system.

Talk to Our Specialists

Visit Insurnest to learn how we help MGAs launch and scale pet insurance programs.

How Do Carrier Reporting Requirements Differ Across Multiple Carrier Partnerships?

Reporting requirements differ across carriers in template formats, field definitions, deadline schedules, delivery methods, and supplementary documentation expectations. MGAs with multiple carrier partnerships must build a reporting infrastructure that accommodates these differences without creating unsustainable manual workload.

1. Template and Format Variations

Each carrier specifies its own bordereaux template, status codes, denial reason codes, and file formats. One carrier may require an Excel workbook with specific tab structures, while another requires CSV files with defined delimiters. The MGA's reporting system must support multiple output formats from a single data source to avoid maintaining separate data sets for each carrier.

2. Deadline Variations

Carriers impose different reporting deadlines. Carrier A might require monthly reports by the 10th business day, while Carrier B requires them by the 15th. Quarterly deadlines vary similarly. The MGA must track all deadlines in a centralized calendar and build workflows that produce carrier-specific reports on the correct schedule.

3. Supplementary Documentation Requirements

Some carriers require supporting documentation beyond standard reports, including sample claim files, customer complaint logs, regulatory correspondence, or market conduct examination results. The MGA should maintain a matrix of carrier-specific supplementary requirements and build those deliverables into the reporting workflow.

Reporting Element	Carrier A Example	Carrier B Example
Bordereaux Format	Excel, specified template	CSV, pipe-delimited
Monthly Deadline	10th business day	15th business day
Status Codes	6-code system (O, C, R, D, S, P)	4-code system (Open, Closed, Denied, Pending)
Large Loss Threshold	$3,000	$5,000
Quarterly Narrative	Required, 2-page minimum	Optional, summary bullet points

What Technology Stack Supports Automated Carrier Claims Reporting?

A cloud-based claims management system with built-in reporting modules, automated bordereaux generation, multi-format export capabilities, reconciliation tools, and carrier API integrations forms the technology foundation for efficient and accurate carrier claims reporting.

1. Claims Management System Reporting Modules

Modern cloud-based CMS platforms include configurable reporting modules that pull data from claims records, apply carrier-specific field mappings, and generate formatted reports on a scheduled basis. The reporting module should support multiple carrier templates simultaneously, with the ability to add new carrier formats without custom development.

2. Automated Bordereaux Generation

Automated bordereaux generation eliminates the manual data extraction and assembly process that consumes hours of staff time and introduces errors. The system extracts all claims activity for the reporting period, applies carrier-specific field mappings and formatting rules, runs validation checks, and produces a submission-ready file. Scheduled generation ensures the bordereaux is available for management review on a predictable timeline.

3. API-Based Carrier Submissions

Where carriers support API-based data exchange, the MGA should implement automated submission that sends validated reports directly to the carrier's systems without manual file transfers. API submission provides confirmation receipts, error handling, and audit trails that email-based submissions lack.

Technology Capability	Manual Process Risk	Automated Alternative
Data extraction	Human selection errors	System-generated from claims database
Format conversion	Template mapping mistakes	Pre-configured carrier templates
Reconciliation	Arithmetic errors	Automated cross-check routines
Submission	Missed deadlines, lost files	Scheduled delivery with confirmation
Audit trail	Incomplete documentation	System-generated logs

MGAs evaluating how to build reporting and analytics dashboards for carrier and internal use should ensure that carrier reporting is a core module, not a bolt-on to internal analytics.

How Can New MGAs Turn Carrier Reporting Into a Competitive Advantage?

New MGAs can turn carrier reporting from a compliance obligation into a competitive advantage by exceeding minimum requirements, adding value-added analysis, and using reporting interactions to deepen the carrier relationship. MGAs that report better than required are the ones that carriers invite into new programs and expanded territories.

1. Exceeding Minimum Reporting Standards

Submit reports ahead of deadline, include optional commentary, and provide proactive analysis of trends that the carrier did not specifically request. When a carrier asks for a monthly loss ratio number, include a one-paragraph narrative explaining the drivers behind that number. This demonstrates analytical capability and proactive program management.

2. Proactive Trend Alerts

Do not wait for the carrier to discover concerning trends in your quarterly report. If mid-month data shows loss ratio spiking or claims frequency increasing unexpectedly, notify the carrier immediately with your assessment and planned response. Proactive communication builds trust and gives the carrier confidence that the MGA is managing the program actively.

3. Benchmarking and Comparative Analysis

Where possible, compare your program's claims metrics against published industry benchmarks and present these comparisons in carrier reports. Showing that your loss ratio, cycle time, or customer satisfaction outperforms industry averages reinforces the carrier's decision to partner with your MGA.

MGAs that successfully implement continuous claims process improvement programs generate the type of operational improvement data that transforms carrier reports from compliance documents into partnership-strengthening presentations.

Transform carrier reporting from a compliance burden into your strongest partnership tool.

Talk to Our Specialists

Visit Insurnest to learn how we help MGAs launch and scale pet insurance programs.

Frequently Asked Questions

What claims reports must pet insurance MGAs submit to carriers monthly?

Pet insurance MGAs must typically submit monthly claims bordereaux, paid and incurred loss summaries, open claims inventory reports, large loss notifications, prompt payment compliance reports, and claims staffing metrics to their carrier partners.

What quarterly claims reporting do carriers require from pet insurance MGAs?

Quarterly reporting typically includes aggregate loss ratio analysis, claims reserve development summaries, fraud detection activity reports, quality audit results, claims trend analysis, customer satisfaction metrics, and compliance exception reports.

What is a claims bordereaux and why do carriers require it from MGAs?

A claims bordereaux is a detailed, line-by-line listing of every claim processed during a reporting period, including claim number, policy number, date of loss, diagnosis, amount paid, amount reserved, and current status. Carriers use bordereaux to monitor MGA claims activity, validate reserves, and audit claims authority usage.

How should new pet insurance MGAs format their claims bordereaux for carriers?

Claims bordereaux should follow the carrier's specified template, typically in Excel or CSV format, with standardized field definitions, consistent date formatting, validated amounts, and reconciliation totals that match the MGA's financial records and the carrier's accounting system.

What happens if a pet insurance MGA fails to meet carrier reporting deadlines?

Failure to meet carrier reporting deadlines can trigger contractual penalties, increased carrier oversight, restriction of claims authority, mandatory corrective action plans, and in severe cases, termination of the MGA agreement. Consistent reporting failures also damage the MGA's reputation for future carrier partnerships.

How do carriers use MGA claims reports to evaluate program performance?

Carriers analyze MGA claims reports to track loss ratio trends, identify claims handling quality issues, verify reserve adequacy, detect fraud patterns, assess prompt payment compliance, and evaluate whether the MGA's claims authority should be expanded, maintained, or restricted.

What technology do pet insurance MGAs need for carrier claims reporting?

MGAs need a claims management system with built-in reporting modules, automated bordereaux generation, data validation tools, reconciliation capabilities, and export functions compatible with carrier-specified formats. API-based reporting integrations with carrier systems reduce manual effort and errors.

Can pet insurance MGAs automate their carrier claims reporting?

Yes. Modern cloud-based claims management systems can automate 80 to 90 percent of carrier reporting through scheduled report generation, automated data validation, carrier-format templates, and API-based submission. Automation reduces reporting errors, ensures deadline compliance, and frees staff for analysis rather than data assembly.

Sources

Posts tagged with#bordereaux reporting

What Carrier Claims Reporting Requirements Must New Pet Insurance MGAs Meet on a Monthly and Quarterly Basis